package com.powernode.teatraceability.dao.circulationprocessmgt;

import com.powernode.teatraceability.pojo.circulationprocessmgt.ClientInfo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.fisco.bcos.sdk.abi.datatypes.Int;
import org.springframework.data.relational.core.sql.In;

import java.util.List;
@Mapper
public interface ClientInfoMapper {

    List<ClientInfo> selectLike(@Param("qydm") String qydm,@Param("clientName") String clientName);

    Integer selectByClientName(String name);

    List<String> selectAllClient(String qydm);
    @Select("select distinct(client_name) from t_client where qydm = #{qydm}")
    List<String> selectAllClientName(String qydm);

    ClientInfo selectById(int id);

    List<ClientInfo> selectAll(String qydm);

    int insert(ClientInfo clientInfo);

    int update(ClientInfo clientInfo);

    int delete(int id);

}
